HRIS Imports: Reports To

This article provides tips and instructions on how to successfully mass import active Reports To employee data in Namely HRIS.

OVERVIEW

An employee's reporting relationship or Reports To data is stored within HRIS, and builds the Org Chart on the People tab. The field that captures Reports To data is also important because certain permissions are dictated by it in Field Group Bundles and Scoped Permissions(for example, managers have the permission to approve their direct reports' time off.)

Reports To data can be edited in bulk by completing a 
Reports To Import. This import is commonly used during an organizational restructure and employee reporting data needs to be updated. 

IMPORT TEMPLATE

  • Template:Reports To Import Template

    • Fields available for import: Reports To (Email), Dotted Line Reports To (Email), Dotted Line Reports (Email)

    • You must also include one Unique Identifier on your template: EmployeeID, Social Security Number or Employee Email (recommended)

  • Reports: The Profile report type in HRIS contains the unique ID needed to complete this import.

 

SAVE A COPY

It's always best practice to save a copy of your data prior to processing an import, in case anything goes awry.

 

PREPARING AND UPLOADING THE IMPORT TEMPLATE

Prepare the Import template

  1. Download the Profile report to collect the employees’ data. 

  • In Namely HRIS, click Reporting under Admin Tools > New Report > select Profile as the Report Type > select Profile Default as the Report Template > Create Report.

  • Refer to HRIS Reports for more information.

  1. Use the unique ID information provided from the report and insert it into the import template. You should only include data on employees that need Reports To information added on your template. 

  2. Once the employee information has been added to the corresponding fields, save the file as a .csv format.

  • Dotted Line Reports To (Column C) assigns the dotted line manager to the employee

  • Dotted Line Reports (column D) assigns the employee as the dotted line manager

Import the template

Tip:

Test the import first by importing a single row of data and confirming that the import is successful on an employee's profile prior to proceeding with the full import. If you need additional support with the import, refer to HRIS Imports.

  1. When the import file is complete, go to Company Settings in Namely HRIS.

  2. Click Settings > Import Data under the General tab.

  3. Scroll down to the Reports To >Import section.

  4. Click Choose File > upload the completed import template > Upload CSV file.

  5. Under Assign Fields, select the unique employee identifier you used in your .CSV file.

  6. Use the dropdown selection to map the fields in your import file to their corresponding Namely Field. 

A screenshot of a computer

Description automatically generated

  1. Click Continue > Import Data.

TROUBLESHOOTING

If an error occurs during the import process, an error report will automatically be generated in a .CSV format. Download the file and refer to Common HRIS Import Error Messagesto resolve the errors. Once the errors have been resolved, re-import only the rows of data that had issues.

If you're still encountering issues or unresolved errors, submit a case in the Help Community and include the import file and any screenshots of the errors as an attachment.

Product Name: HRIS Settings

Feature: Company Settings

Function: Imports 

TIPS

  • Your .csv file cannot exceed 5 MB.

  • The first row of each column should be treated as a header row.

  • Each employee must be listed on a separate row.

  • Each row must have Unique ID to match your records to Namely records. Employee email is used as the primary unique identifier within Namely.

  • Dates should be formatted: MM/DD/YYYY

  • Theterm Children under Field Group Bundles > Teams refers to all employees under a specific manager. This item must be checked to ensure a user can view their direct reports.

A screenshot of a computer

Description automatically generated